﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace John
{
    public partial class ascx_producte : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                getHotDataList();//热卖产品
                getNewDataList();//最新上架
            }

        }
        private void getHotDataList()//推荐产品
        {
            try
            {
                HDataList.DataSource = UserScreenControl.GetHotDataList("Producte");
                HDataList.DataBind();
            }
            catch (Exception ex)
            {
                Response.Write(string.Format("<script>alert('{0}！')</script>", ex.ToString()));
            }

        }
        private void getNewDataList()//最新上架
        {
            DBConn myDB = new DBConn();
            string sql = "select top 9 * from Products order by PID desc";
            NDataList.DataSource = myDB.getDataReader(sql);
            NDataList.DataBind();
            myDB.Close();
        }
    }
}
